﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="WorkItemsDataSet" targetNamespace="http://tempuri.org/WorkItemsDataSet.xsd" xmlns:mstns="http://tempuri.org/WorkItemsDataSet.xsd" xmlns="http://tempuri.org/WorkItemsDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SMSConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SMSConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Workflows.Properties.Settings.GlobalReference.Default.SMSConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ASPNETDBConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ASPNETDBConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Workflows.Properties.Settings.GlobalReference.Default.ASPNETDBConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkTypesTableAdapter" GeneratorDataComponentClassName="WorkTypesTableAdapter" Name="WorkTypes" UserDataComponentName="WorkTypesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SMSConnectionString (Settings)" DbObjectName="SMS.dbo.WorkTypes" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [WorkTypes] WHERE (([WorkTypeName] = @Original_WorkTypeName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [WorkTypes] ([WorkTypeName]) VALUES (@WorkTypeName);
SELECT WorkTypeName FROM WorkTypes WHERE (WorkTypeName = @WorkTypeName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   WorkTypes.*
FROM      WorkTypes</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [WorkTypes] SET [WorkTypeName] = @WorkTypeName WHERE (([WorkTypeName] = @Original_WorkTypeName));
SELECT WorkTypeName FROM WorkTypes WHERE (WorkTypeName = @WorkTypeName)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkTypeName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkTypeName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkTypeName" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WorkTypeName" DataSetColumn="WorkTypeName" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="WorkItemsTableAdapter" GeneratorDataComponentClassName="WorkItemsTableAdapter" Name="WorkItems" UserDataComponentName="WorkItemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SMSConnectionString (Settings)" DbObjectName="SMS.dbo.WorkItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [WorkItems] WHERE (([WorkItemID] = @Original_WorkItemID) AND ((@IsNull_WorkItemName = 1 AND [WorkItemName] IS NULL) OR ([WorkItemName] = @Original_WorkItemName)) AND ((@IsNull_WorkItemType = 1 AND [WorkItemType] IS NULL) OR ([WorkItemType] = @Original_WorkItemType)) AND ([Description] = @Original_Description) AND ([IsAnonymous] = @Original_IsAnonymous) AND ([DateReport] = @Original_DateReport) AND ((@IsNull_Advice = 1 AND [Advice] IS NULL) OR ([Advice] = @Original_Advice)) AND ((@IsNull_OtherAdvice = 1 AND [OtherAdvice] IS NULL) OR ([OtherAdvice] = @Original_OtherAdvice)) AND ((@IsNull_Approved = 1 AND [Approved] IS NULL) OR ([Approved] = @Original_Approved)) AND ((@IsNull_ReporterID = 1 AND [ReporterID] IS NULL) OR ([ReporterID] = @Original_ReporterID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WorkItemName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WorkItemType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Advice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OtherAdvice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OtherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Approved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReporterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [WorkItems] ([WorkItemID], [WorkItemName], [WorkItemType], [Description], [IsAnonymous], [DateReport], [Advice], [OtherAdvice], [Approved], [ReporterID]) VALUES (@WorkItemID, @WorkItemName, @WorkItemType, @Description, @IsAnonymous, @DateReport, @Advice, @OtherAdvice, @Approved, @ReporterID);
SELECT WorkItemID, WorkItemName, WorkItemType, Description, IsAnonymous, DateReport, Advice, OtherAdvice, Approved, ReporterID FROM WorkItems WHERE (WorkItemID = @WorkItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OtherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   WorkItems.*
FROM      WorkItems</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [WorkItems] SET [WorkItemID] = @WorkItemID, [WorkItemName] = @WorkItemName, [WorkItemType] = @WorkItemType, [Description] = @Description, [IsAnonymous] = @IsAnonymous, [DateReport] = @DateReport, [Advice] = @Advice, [OtherAdvice] = @OtherAdvice, [Approved] = @Approved, [ReporterID] = @ReporterID WHERE (([WorkItemID] = @Original_WorkItemID) AND ((@IsNull_WorkItemName = 1 AND [WorkItemName] IS NULL) OR ([WorkItemName] = @Original_WorkItemName)) AND ((@IsNull_WorkItemType = 1 AND [WorkItemType] IS NULL) OR ([WorkItemType] = @Original_WorkItemType)) AND ([Description] = @Original_Description) AND ([IsAnonymous] = @Original_IsAnonymous) AND ([DateReport] = @Original_DateReport) AND ((@IsNull_Advice = 1 AND [Advice] IS NULL) OR ([Advice] = @Original_Advice)) AND ((@IsNull_OtherAdvice = 1 AND [OtherAdvice] IS NULL) OR ([OtherAdvice] = @Original_OtherAdvice)) AND ((@IsNull_Approved = 1 AND [Approved] IS NULL) OR ([Approved] = @Original_Approved)) AND ((@IsNull_ReporterID = 1 AND [ReporterID] IS NULL) OR ([ReporterID] = @Original_ReporterID)));
SELECT WorkItemID, WorkItemName, WorkItemType, Description, IsAnonymous, DateReport, Advice, OtherAdvice, Approved, ReporterID FROM WorkItems WHERE (WorkItemID = @WorkItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@OtherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WorkItemName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkItemName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WorkItemType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_WorkItemType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="WorkItemType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsAnonymous" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsAnonymous" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateReport" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateReport" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Advice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Advice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Advice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OtherAdvice" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_OtherAdvice" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="OtherAdvice" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Approved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Approved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Approved" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReporterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ReporterID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ReporterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="WorkItemID" DataSetColumn="WorkItemID" />
              <Mapping SourceColumn="WorkItemName" DataSetColumn="WorkItemName" />
              <Mapping SourceColumn="WorkItemType" DataSetColumn="WorkItemType" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="IsAnonymous" DataSetColumn="IsAnonymous" />
              <Mapping SourceColumn="DateReport" DataSetColumn="DateReport" />
              <Mapping SourceColumn="Advice" DataSetColumn="Advice" />
              <Mapping SourceColumn="OtherAdvice" DataSetColumn="OtherAdvice" />
              <Mapping SourceColumn="Approved" DataSetColumn="Approved" />
              <Mapping SourceColumn="ReporterID" DataSetColumn="ReporterID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SMSConnectionString (Settings)" DbObjectName="SMS.dbo.WorkItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActivityGuid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByActivityGuid" GeneratorSourceName="FillByActivityGuid" GetMethodModifier="Public" GetMethodName="GetDataByActivityGuid" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByActivityGuid" UserSourceName="FillByActivityGuid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   WorkItemID, WorkItemName, WorkItemType, Description, IsAnonymous, DateReport, Advice, OtherAdvice, Approved, ReporterID FROM dbo.WorkItems WHERE (WorkItemID IN (SELECT WorkItemID FROM UserActivitiesWorkItems WHERE (ActivityGuid = @activityGuid)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="activityGuid" ColumnName="" DataSourceName="" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" Scale="0" Size="36" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UserActivitiesWorkItemsTableAdapter" GeneratorDataComponentClassName="UserActivitiesWorkItemsTableAdapter" Name="UserActivitiesWorkItems" UserDataComponentName="UserActivitiesWorkItemsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SMSConnectionString (Settings)" DbObjectName="SMS.dbo.UserActivitiesWorkItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [UserActivitiesWorkItems] WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([WorkItemID] = @Original_WorkItemID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [UserActivitiesWorkItems] ([ActivityGuid], [WorkItemID]) VALUES (@ActivityGuid, @WorkItemID);
SELECT ActivityGuid, WorkItemID FROM UserActivitiesWorkItems WHERE (ActivityGuid = @ActivityGuid) AND (WorkItemID = @WorkItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   UserActivitiesWorkItems.*
FROM      UserActivitiesWorkItems</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [UserActivitiesWorkItems] SET [ActivityGuid] = @ActivityGuid, [WorkItemID] = @WorkItemID WHERE (([ActivityGuid] = @Original_ActivityGuid) AND ([WorkItemID] = @Original_WorkItemID));
SELECT ActivityGuid, WorkItemID FROM UserActivitiesWorkItems WHERE (ActivityGuid = @ActivityGuid) AND (WorkItemID = @WorkItemID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_ActivityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_WorkItemID" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="WorkItemID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ActivityGuid" DataSetColumn="ActivityGuid" />
              <Mapping SourceColumn="WorkItemID" DataSetColumn="WorkItemID" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="SMSConnectionString (Settings)" DbObjectName="SMS.dbo.UserActivitiesWorkItems" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByActivityGuid" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByActivityGuid" GeneratorSourceName="FillByActivityGuid" GetMethodModifier="Public" GetMethodName="GetDataByActivityGuid" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByActivityGuid" UserSourceName="FillByActivityGuid">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT ActivityGuid, WorkItemID FROM dbo.UserActivitiesWorkItems WHERE (ActivityGuid = @activityGuid)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="activityGuid" ColumnName="ActivityGuid" DataSourceName="SMS.dbo.UserActivitiesWorkItems" DataTypeServer="nchar(36)" DbType="String" Direction="Input" ParameterName="@activityGuid" Precision="0" ProviderType="NChar" Scale="0" Size="36" SourceColumn="ActivityGuid" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="WorkItemsDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="WorkItemsDataSet" msprop:Generator_DataSetName="WorkItemsDataSet" msprop:EnableTableAdapterManager="true">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="WorkTypes" msprop:Generator_UserTableName="WorkTypes" msprop:Generator_RowDeletedName="WorkTypesRowDeleted" msprop:Generator_TableClassName="WorkTypesDataTable" msprop:Generator_RowChangedName="WorkTypesRowChanged" msprop:Generator_RowClassName="WorkTypesRow" msprop:Generator_RowChangingName="WorkTypesRowChanging" msprop:Generator_RowEvArgName="WorkTypesRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkTypesRowChangeEventHandler" msprop:Generator_TablePropName="WorkTypes" msprop:Generator_TableVarName="tableWorkTypes" msprop:Generator_RowDeletingName="WorkTypesRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkTypeName" msprop:Generator_UserColumnName="WorkTypeName" msprop:Generator_ColumnPropNameInRow="WorkTypeName" msprop:Generator_ColumnVarNameInTable="columnWorkTypeName" msprop:Generator_ColumnPropNameInTable="WorkTypeNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="WorkItems" msprop:Generator_UserTableName="WorkItems" msprop:Generator_RowDeletedName="WorkItemsRowDeleted" msprop:Generator_TableClassName="WorkItemsDataTable" msprop:Generator_RowChangedName="WorkItemsRowChanged" msprop:Generator_RowClassName="WorkItemsRow" msprop:Generator_RowChangingName="WorkItemsRowChanging" msprop:Generator_RowEvArgName="WorkItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="WorkItemsRowChangeEventHandler" msprop:Generator_TablePropName="WorkItems" msprop:Generator_TableVarName="tableWorkItems" msprop:Generator_RowDeletingName="WorkItemsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="WorkItemID" msprop:Generator_UserColumnName="WorkItemID" msprop:Generator_ColumnPropNameInRow="WorkItemID" msprop:Generator_ColumnVarNameInTable="columnWorkItemID" msprop:Generator_ColumnPropNameInTable="WorkItemIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemName" msprop:Generator_UserColumnName="WorkItemName" msprop:Generator_ColumnPropNameInRow="WorkItemName" msprop:Generator_ColumnVarNameInTable="columnWorkItemName" msprop:Generator_ColumnPropNameInTable="WorkItemNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemType" msprop:Generator_UserColumnName="WorkItemType" msprop:Generator_ColumnPropNameInRow="WorkItemType" msprop:Generator_ColumnVarNameInTable="columnWorkItemType" msprop:Generator_ColumnPropNameInTable="WorkItemTypeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsAnonymous" msprop:Generator_UserColumnName="IsAnonymous" msprop:Generator_ColumnPropNameInRow="IsAnonymous" msprop:Generator_ColumnVarNameInTable="columnIsAnonymous" msprop:Generator_ColumnPropNameInTable="IsAnonymousColumn" type="xs:boolean" />
              <xs:element name="DateReport" msprop:Generator_UserColumnName="DateReport" msprop:Generator_ColumnPropNameInRow="DateReport" msprop:Generator_ColumnVarNameInTable="columnDateReport" msprop:Generator_ColumnPropNameInTable="DateReportColumn" type="xs:dateTime" />
              <xs:element name="Advice" msprop:Generator_UserColumnName="Advice" msprop:Generator_ColumnPropNameInRow="Advice" msprop:Generator_ColumnVarNameInTable="columnAdvice" msprop:Generator_ColumnPropNameInTable="AdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OtherAdvice" msprop:Generator_UserColumnName="OtherAdvice" msprop:Generator_ColumnPropNameInRow="OtherAdvice" msprop:Generator_ColumnVarNameInTable="columnOtherAdvice" msprop:Generator_ColumnPropNameInTable="OtherAdviceColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Approved" msprop:Generator_UserColumnName="Approved" msprop:Generator_ColumnPropNameInRow="Approved" msprop:Generator_ColumnVarNameInTable="columnApproved" msprop:Generator_ColumnPropNameInTable="ApprovedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ReporterID" msprop:Generator_UserColumnName="ReporterID" msprop:Generator_ColumnPropNameInRow="ReporterID" msprop:Generator_ColumnVarNameInTable="columnReporterID" msprop:Generator_ColumnPropNameInTable="ReporterIDColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UserActivitiesWorkItems" msprop:Generator_UserTableName="UserActivitiesWorkItems" msprop:Generator_RowDeletedName="UserActivitiesWorkItemsRowDeleted" msprop:Generator_TableClassName="UserActivitiesWorkItemsDataTable" msprop:Generator_RowChangedName="UserActivitiesWorkItemsRowChanged" msprop:Generator_RowClassName="UserActivitiesWorkItemsRow" msprop:Generator_RowChangingName="UserActivitiesWorkItemsRowChanging" msprop:Generator_RowEvArgName="UserActivitiesWorkItemsRowChangeEvent" msprop:Generator_RowEvHandlerName="UserActivitiesWorkItemsRowChangeEventHandler" msprop:Generator_TablePropName="UserActivitiesWorkItems" msprop:Generator_TableVarName="tableUserActivitiesWorkItems" msprop:Generator_RowDeletingName="UserActivitiesWorkItemsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ActivityGuid" msprop:Generator_UserColumnName="ActivityGuid" msprop:Generator_ColumnPropNameInRow="ActivityGuid" msprop:Generator_ColumnVarNameInTable="columnActivityGuid" msprop:Generator_ColumnPropNameInTable="ActivityGuidColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WorkItemID" msprop:Generator_UserColumnName="WorkItemID" msprop:Generator_ColumnPropNameInRow="WorkItemID" msprop:Generator_ColumnVarNameInTable="columnWorkItemID" msprop:Generator_ColumnPropNameInTable="WorkItemIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkTypes" />
      <xs:field xpath="mstns:WorkTypeName" />
    </xs:unique>
    <xs:unique name="WorkItems_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:WorkItems" />
      <xs:field xpath="mstns:WorkItemID" />
    </xs:unique>
    <xs:unique name="UserActivitiesWorkItems_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UserActivitiesWorkItems" />
      <xs:field xpath="mstns:ActivityGuid" />
      <xs:field xpath="mstns:WorkItemID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_WorkItems_WorkTypes" msdata:parent="WorkTypes" msdata:child="WorkItems" msdata:parentkey="WorkTypeName" msdata:childkey="WorkItemType" msprop:Generator_UserRelationName="FK_WorkItems_WorkTypes" msprop:Generator_RelationVarName="relationFK_WorkItems_WorkTypes" msprop:Generator_UserChildTable="WorkItems" msprop:Generator_UserParentTable="WorkTypes" msprop:Generator_ParentPropName="WorkTypesRow" msprop:Generator_ChildPropName="GetWorkItemsRows" />
      <msdata:Relationship name="FK_UserActivitiesWorkItems_WorkItems" msdata:parent="WorkItems" msdata:child="UserActivitiesWorkItems" msdata:parentkey="WorkItemID" msdata:childkey="WorkItemID" msprop:Generator_UserRelationName="FK_UserActivitiesWorkItems_WorkItems" msprop:Generator_RelationVarName="relationFK_UserActivitiesWorkItems_WorkItems" msprop:Generator_UserChildTable="UserActivitiesWorkItems" msprop:Generator_UserParentTable="WorkItems" msprop:Generator_ParentPropName="WorkItemsRow" msprop:Generator_ChildPropName="GetUserActivitiesWorkItemsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>